﻿<?xml version="1.0" encoding="utf-8"?>
<DDLs>
  <table type="add" name="Lobby">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
  </table>
  <table type="add" name="patient">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Payor" key="False">
      <Domain Type="Enumerated">
        <Item>AAA</Item>
        <Item>FBI</Item>
        <Item>$$$</Item>
        <Item>LMAO</Item>
      </Domain>
    </column>
    <column name="Ethnicity" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="Other" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="HawaiianPacificIslander" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="Asian" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="AmericanIndian" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="Black" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="White" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="gender" key="False">
      <Domain Type="Enumerated">
        <Item>Unknown</Item>
        <Item>Male</Item>
        <Item>Female</Item>
      </Domain>
    </column>
    <column name="DOB" key="False">
      <Domain Type="DateTime" />
    </column>
    <column name="MRN" key="False">
      <Domain Type="String" Width="15" />
    </column>
    <column name="SSN" key="False">
      <Domain Type="String" Width="11" />
    </column>
    <column name="lastname" key="False">
      <Domain Type="String" Width="50" />
    </column>
    <column name="midname" key="False">
      <Domain Type="String" Width="30" />
    </column>
    <column name="firstname" key="False">
      <Domain Type="String" Width="50" />
    </column>
    <column name="country" key="False">
      <Domain Type="Enumerated">
        <Item>USA</Item>
        <Item>Some other country</Item>
      </Domain>
    </column>
    <column name="state" key="False">
      <Domain Type="Enumerated">
        <Item>AK</Item>
        <Item>AL</Item>
        <Item>AR</Item>
        <Item>AZ</Item>
        <Item>CA</Item>
        <Item>CO</Item>
        <Item>CT</Item>
        <Item>DC</Item>
        <Item>DE</Item>
        <Item>FL</Item>
        <Item>GA</Item>
        <Item>HI</Item>
        <Item>IA</Item>
        <Item>ID</Item>
        <Item>IL</Item>
        <Item>IN</Item>
        <Item>KY</Item>
        <Item>LO</Item>
        <Item>MA</Item>
        <Item>MD</Item>
        <Item>ME</Item>
        <Item>MI</Item>
        <Item>MN</Item>
        <Item>MO</Item>
        <Item>NC</Item>
        <Item>ND</Item>
        <Item>NE</Item>
        <Item>NJ</Item>
        <Item>NH</Item>
        <Item>NM</Item>
        <Item>NY</Item>
        <Item>OH</Item>
        <Item>OK</Item>
        <Item>OR</Item>
        <Item>PA</Item>
        <Item>RI</Item>
        <Item>SC</Item>
        <Item>SD</Item>
        <Item>TN</Item>
        <Item>TX</Item>
        <Item>UT</Item>
        <Item>VI</Item>
        <Item>VT</Item>
        <Item>WA</Item>
        <Item>WI</Item>
        <Item>WV</Item>
        <Item>WY</Item>
      </Domain>
    </column>
    <column name="notes" key="False">
      <Domain Type="String" Width="300" />
    </column>
    <column name="zip" key="False">
      <Domain Type="String" Width="10" />
    </column>
    <column name="city" key="False">
      <Domain Type="String" Width="25" />
    </column>
    <column name="phone2" key="False">
      <Domain Type="String" Width="30" />
    </column>
    <column name="phone1" key="False">
      <Domain Type="String" Width="30" />
    </column>
    <column name="address2" key="False">
      <Domain Type="String" Width="50" />
    </column>
    <column name="address1" key="False">
      <Domain Type="String" Width="50" />
    </column>
  </table>
  <fk type="add" childTable="patient" childColumns="fk" childConditions="" parentTable="Lobby" parentColumns="id" parentConditions="" />
  <table type="add" name="proc_main">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Form" key="False">
      <Domain Type="Enumerated">
        <Item>Colonoscopy</Item>
        <Item>EGD</Item>
      </Domain>
    </column>
    <column name="Created" key="False">
      <Domain Type="DateTime" />
    </column>
  </table>
  <fk type="add" childTable="proc_main" childColumns="fk" childConditions="" parentTable="patient" parentColumns="id" parentConditions="" />
  <table type="add" name="COL">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="ProcedureDate" key="False">
      <Domain Type="DateTime" />
    </column>
    <column name="allergyTxt" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="allergy" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cfNoHistOfMEdIll" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="medHx" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="comments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfNoPriSurg" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="surgHx" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="alcohol" key="False">
      <Domain Type="Enumerated">
        <Item>Abstains</Item>
        <Item>Occasional (average less than daily)</Item>
        <Item>Moderate (1-2 drinks per day)</Item>
        <Item>Heavy (&gt;2 drinks per day)</Item>
      </Domain>
    </column>
    <column name="noYears" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="noPacks" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="smoking" key="False">
      <Domain Type="Enumerated">
        <Item>Never smoked (&lt; 100 cigs. lifetime)</Item>
        <Item>Current smoker</Item>
        <Item>Ex Smoker</Item>
        <Item>Unknown</Item>
      </Domain>
    </column>
    <column name="medsOtherTxt" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbOtherAntiMeds" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbAntiCoagPlan" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="coumadin" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="aspirin" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="nsaid" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="plavix" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="heparin" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="lmwh" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cox2" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="antiinflamCoag" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="labTxt" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="lab" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="EntireExamWNL" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="Systolic" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="Pulse" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="Diastolic" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="Weight" key="False">
      <Domain Type="SmallInteger" MaxValue="2000" />
    </column>
    <column name="Height" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="PEComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="AbdominalExamWNL" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>Abnormal</Item>
        <Item>Not Performed</Item>
      </Domain>
    </column>
    <column name="AirwayExamWNL" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>Abnormal</Item>
        <Item>Not Performed</Item>
      </Domain>
    </column>
    <column name="NeurologicalExamWNL" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>Abnormal</Item>
        <Item>Not Performed</Item>
      </Domain>
    </column>
    <column name="MentalStatusExamWNL" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>Abnormal</Item>
        <Item>Not Performed</Item>
      </Domain>
    </column>
    <column name="HEENTExamWNL" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>Abnormal</Item>
        <Item>Not Performed</Item>
      </Domain>
    </column>
    <column name="ExtremityExamWNL" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>Abnormal</Item>
        <Item>Not Performed</Item>
      </Domain>
    </column>
    <column name="CardioPulmonaryExamWNL" key="False">
      <Domain Type="Enumerated">
        <Item>Normal</Item>
        <Item>Abnormal</Item>
        <Item>Not Performed</Item>
      </Domain>
    </column>
    <column name="PhysicalExamPerformed" key="False">
      <Domain Type="DateTime" />
    </column>
    <column name="varices" key="False">
      <Domain Type="Enumerated">
        <Item>Known history of varices</Item>
        <Item>No known history of varices</Item>
        <Item>Unknown history of varices</Item>
      </Domain>
    </column>
    <column name="cbPriorYear" key="False">
      <Domain Type="Enumerated">
        <Item>&lt;1990</Item>
        <Item>1990</Item>
        <Item>1991</Item>
        <Item>1992</Item>
        <Item>1993</Item>
        <Item>1994</Item>
        <Item>1995</Item>
        <Item>1996</Item>
        <Item>1997</Item>
        <Item>1998</Item>
        <Item>1999</Item>
        <Item>2000</Item>
        <Item>2001</Item>
        <Item>2002</Item>
        <Item>2003</Item>
        <Item>2004</Item>
        <Item>2005</Item>
        <Item>2006</Item>
        <Item>2007</Item>
        <Item>2008</Item>
        <Item>2009</Item>
      </Domain>
    </column>
    <column name="priorSurv" key="False">
      <Domain Type="Enumerated">
        <Item>History of prior surveillance</Item>
        <Item>No known prior surveillance</Item>
        <Item>Unknown if prior surveillance</Item>
      </Domain>
    </column>
    <column name="priorMonth" key="False">
      <Domain Type="Enumerated">
        <Item>Jan</Item>
        <Item>Feb</Item>
        <Item>Mar</Item>
        <Item>Apr</Item>
        <Item>May</Item>
        <Item>Jun</Item>
        <Item>July</Item>
        <Item>Aug</Item>
        <Item>Sep</Item>
        <Item>Oct</Item>
        <Item>Nov</Item>
        <Item>Dec</Item>
      </Domain>
    </column>
    <column name="cfVaricesOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gastric" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="duodenal" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="esophageal" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="bldStatus" key="False">
      <Domain Type="Enumerated">
        <Item>Complete</Item>
        <Item>Incomplete</Item>
        <Item>Not attempted</Item>
        <Item>Unknown</Item>
      </Domain>
    </column>
    <column name="priorBld" key="False">
      <Domain Type="Enumerated">
        <Item>Known prior bleed</Item>
        <Item>No prior bleed known</Item>
        <Item>Unknown if prior bleed</Item>
      </Domain>
    </column>
    <column name="bldComments" key="False">
      <Domain Type="String" Width="512" />
    </column>
    <column name="portalVeinThrombosis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="evidenceOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="histoCirrhosis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="portalHTN" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="abnlLab" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="etiologyOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hepB" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hepC" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="nash" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="psc" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pbc" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cryptogenic" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hisAlcohol" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="bilAtresia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="autoimmuneHep" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cf" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="childspughClass" key="False">
      <Domain Type="String" Width="512" />
    </column>
    <column name="bilirubin" key="False">
      <Domain Type="Enumerated">
        <Item>&lt; 2.0 mg/dL</Item>
        <Item>2.0-3.0 mg/dL</Item>
        <Item>&gt; 3.0 mg/dL</Item>
      </Domain>
    </column>
    <column name="pt" key="False">
      <Domain Type="Enumerated">
        <Item>&lt; 1.7</Item>
        <Item>1.7 - 2.3</Item>
        <Item>&gt; 2.3</Item>
      </Domain>
    </column>
    <column name="albumin" key="False">
      <Domain Type="Enumerated">
        <Item>&gt; 3.5 g/dL</Item>
        <Item>2.8-3.5 g/dL</Item>
        <Item>&lt; 2.8 g/dL</Item>
      </Domain>
    </column>
    <column name="ascites" key="False">
      <Domain Type="Enumerated">
        <Item>None</Item>
        <Item>Moderate or easily treated</Item>
        <Item>Severe or intractable</Item>
      </Domain>
    </column>
    <column name="encephalopathy" key="False">
      <Domain Type="Enumerated">
        <Item>None</Item>
        <Item>Mild</Item>
        <Item>Severe</Item>
      </Domain>
    </column>
    <column name="tbIndComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfIndOtherSuspectedMal" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfHerColCancer" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamAdPolyposis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfIndUlcerativeColitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfIndCrohnsDisease" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfColRecCancer" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfAdPolyps" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="nbIndAgeOfDx" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="cfHistOFBreastCancer" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistPolyps" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistColCancer" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfScreeningAvg" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfAbnormalXray" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfOtherGIBLoodLoss" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfMelena" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfHematochezia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFOBT" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfLowFerritin" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfAnemia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfOtherIntervention" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStent" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPolypectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfHemorrhoidalBanding" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDecompression" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfAblationOfAVM" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfOtherSx" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfWeightLoss" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfGISx" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDiarr" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfConst" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfBowelHab" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfAbPain" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfOtherNonMalDiagnosis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfUlcerativeColitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRadiationColitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfIschemicColitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfInfectiousColitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfGraftHostDisease" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfCrohnsDisease" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfCDifficileColits" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="raCDifficileColitis" key="False">
      <Domain Type="Enumerated">
        <Item>Suspected</Item>
        <Item>Established</Item>
      </Domain>
    </column>
    <column name="raChronsDisease" key="False">
      <Domain Type="Enumerated">
        <Item>Suspected</Item>
        <Item>Established</Item>
      </Domain>
    </column>
    <column name="raGraftHostDisease" key="False">
      <Domain Type="Enumerated">
        <Item>Suspected</Item>
        <Item>Established</Item>
      </Domain>
    </column>
    <column name="raInfectiousColitis" key="False">
      <Domain Type="Enumerated">
        <Item>Suspected</Item>
        <Item>Established</Item>
      </Domain>
    </column>
    <column name="raIschemicColitis" key="False">
      <Domain Type="Enumerated">
        <Item>Suspected</Item>
        <Item>Established</Item>
      </Domain>
    </column>
    <column name="raRadiationColitis" key="False">
      <Domain Type="Enumerated">
        <Item>Suspected</Item>
        <Item>Established</Item>
      </Domain>
    </column>
    <column name="raUlcerativeColitis" key="False">
      <Domain Type="Enumerated">
        <Item>Suspected</Item>
        <Item>Established</Item>
      </Domain>
    </column>
    <column name="tbPreprocComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfPatientIntubated" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfResidualSedation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbSedManagedBy" key="False">
      <Domain Type="Enumerated">
        <Item>Anesthesiologist</Item>
        <Item>Assistant</Item>
        <Item>Endoscopist - Attending Physician</Item>
        <Item>Endoscopist - Fellow</Item>
        <Item>Endoscopist - Nurse Practitioner</Item>
        <Item>Endoscopist - Physicians assistant</Item>
        <Item>ENT staff</Item>
        <Item>ICU staff</Item>
        <Item>Nurse</Item>
        <Item>Nurse anesthetist</Item>
        <Item>Nurse assistant</Item>
        <Item>Nurse practitioner</Item>
        <Item>Oncology staff</Item>
        <Item>Pathology staff</Item>
        <Item>Physician assistant</Item>
        <Item>Primary care physician</Item>
        <Item>Radiology staff</Item>
        <Item>Research staff</Item>
        <Item>Resident</Item>
        <Item>Student</Item>
        <Item>Surgeon</Item>
        <Item>Technician</Item>
      </Domain>
    </column>
    <column name="cbLevelOfSedation" key="False">
      <Domain Type="Enumerated">
        <Item>No sedation</Item>
        <Item>Anxiolytic sedation</Item>
        <Item>Moderate (concious sedation)</Item>
        <Item>Deep sedation</Item>
        <Item>General anesthesia</Item>
      </Domain>
    </column>
    <column name="cfNoSedMed" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfOtherSedMedOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPreprocAntibiotics" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbASAAssesedBy" key="False">
      <Domain Type="Enumerated">
        <Item>Anesthesiologist</Item>
        <Item>Assistant</Item>
        <Item>Endoscopist - Attending Physician</Item>
        <Item>Endoscopist - Fellow</Item>
        <Item>Endoscopist - Nurse Practitioner</Item>
        <Item>Endoscopist - Physicians assistant</Item>
        <Item>ENT staff</Item>
        <Item>ICU staff</Item>
        <Item>Nurse</Item>
        <Item>Nurse anesthetist</Item>
        <Item>Nurse assistant</Item>
        <Item>Nurse practitioner</Item>
        <Item>Oncology staff</Item>
        <Item>Pathology staff</Item>
        <Item>Physician assistant</Item>
        <Item>Primary care physician</Item>
        <Item>Radiology staff</Item>
        <Item>Research staff</Item>
        <Item>Resident</Item>
        <Item>Student</Item>
        <Item>Surgeon</Item>
        <Item>Technician</Item>
      </Domain>
    </column>
    <column name="cbASAClass" key="False">
      <Domain Type="Enumerated">
        <Item>I   - Normal healthy patient</Item>
        <Item>II  - Mild systemic disease</Item>
        <Item>III - Severe systemic disease</Item>
        <Item>IV  - Severe systemic disease; life-threatening</Item>
        <Item>V   - Moribund; not expected to survive</Item>
      </Domain>
    </column>
    <column name="cfMonOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfMonPulseOximetry" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfMonECG" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfMonSuppOxygen" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfMonBloodPress" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="nbOverNoHours" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="tbPrepDose" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbPrepUsed" key="False">
      <Domain Type="Enumerated">
        <Item>B prep kit</Item>
        <Item>Fleets enema</Item>
        <Item>Fleets prep kit</Item>
        <Item>Golytely</Item>
        <Item>Halflytely</Item>
        <Item>None</Item>
        <Item>Phospho soda</Item>
        <Item>Visicol</Item>
        <Item>Mag citrate</Item>
      </Domain>
    </column>
    <column name="cbRespEndoscopist" key="False">
      <Domain Type="Enumerated">
        <Item>test</Item>
      </Domain>
    </column>
    <column name="cfAttendingPresent" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbConsentForResearch" key="False">
      <Domain Type="Enumerated">
        <Item>Consented</Item>
        <Item>Did not consent</Item>
        <Item>Not asked for consent</Item>
      </Domain>
    </column>
    <column name="cbEndoscopyPerformedIn" key="False">
      <Domain Type="Enumerated">
        <Item>Hospital endoscopy suite</Item>
        <Item>Ambulatory surgery center</Item>
        <Item>Office</Item>
      </Domain>
    </column>
    <column name="raPatAdminStatus" key="False">
      <Domain Type="Enumerated">
        <Item>Outpatient</Item>
        <Item>Inpatient</Item>
        <Item>ED</Item>
      </Domain>
    </column>
    <column name="cfTimeout" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gComboBox1" key="False">
      <Domain Type="Enumerated">
        <Item>Physician</Item>
        <Item>Endoscopist</Item>
        <Item>GI assistant</Item>
        <Item>Staff nurse</Item>
      </Domain>
    </column>
    <column name="cbPersonConsenting" key="False">
      <Domain Type="Enumerated">
        <Item>Patient</Item>
        <Item>Family Member</Item>
        <Item>Guardian</Item>
      </Domain>
    </column>
    <column name="raConsentObtained" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="tbProcComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbProcAftRecoverySent" key="False">
      <Domain Type="Enumerated">
        <Item>back to hospital</Item>
        <Item>to hospital for admission</Item>
        <Item>home</Item>
      </Domain>
    </column>
    <column name="cbProcAftProcSent" key="False">
      <Domain Type="Enumerated">
        <Item>home</Item>
        <Item>to ICU</Item>
        <Item>to NICU</Item>
        <Item>to PICU</Item>
        <Item>to short stay unit</Item>
        <Item>to surgery</Item>
        <Item>to hospital</Item>
        <Item>remian in endo suite</Item>
        <Item>to recovery</Item>
      </Domain>
    </column>
    <column name="nbProcDurScopeSec" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbProcDurScopeMin" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbProcDurCecumSec" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbProcDurCecumMin" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbProcBloodloss" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="cbProcTolerance" key="False">
      <Domain Type="Enumerated">
        <Item>Excellent</Item>
        <Item>Good</Item>
        <Item>Fair</Item>
        <Item>Poor</Item>
      </Domain>
    </column>
    <column name="raABComp" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cbProcPatientPos" key="False">
      <Domain Type="Enumerated">
        <Item>From side to side</Item>
        <Item>Left side to back</Item>
        <Item>On left side</Item>
        <Item>On right side</Item>
        <Item>Prone</Item>
        <Item>Right side to back</Item>
        <Item>Supine</Item>
      </Domain>
    </column>
    <column name="raProcFlouroscopy" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="raProcImages" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cbProcActReached" key="False">
      <Domain Type="Enumerated">
        <Item>Anastamosis</Item>
        <Item>Anus</Item>
        <Item>Rectum</Item>
        <Item>Sigmoid colon</Item>
        <Item>Descending colon</Item>
        <Item>Splenic flexure</Item>
        <Item>Transverse colon</Item>
        <Item>Hepatic flexure</Item>
        <Item>Ascending colon</Item>
        <Item>Cecum</Item>
        <Item>Terminal ileum</Item>
      </Domain>
    </column>
    <column name="cbProcIntended" key="False">
      <Domain Type="Enumerated">
        <Item>Anastamosis</Item>
        <Item>Anus</Item>
        <Item>Rectum</Item>
        <Item>Sigmoid colon</Item>
        <Item>Descending colon</Item>
        <Item>Splenic flexure</Item>
        <Item>Transverse colon</Item>
        <Item>Hepatic flexure</Item>
        <Item>Ascending colon</Item>
        <Item>Cecum</Item>
        <Item>Terminal ileum</Item>
      </Domain>
    </column>
    <column name="cbProcQualBowelPrep" key="False">
      <Domain Type="Enumerated">
        <Item>Excellent - no more than small bits of adherent fecal material</Item>
        <Item>Good - small amounts of feces or fluid not interfering with exam</Item>
        <Item>Fair - adequate to detect polyps &gt; 5 mm</Item>
        <Item>Poor - inadequate to detect polyps &gt; 5 mm</Item>
      </Domain>
    </column>
    <column name="cfProcIncompOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcStricture" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcPatUnstable" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcDiscomfort" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcObstruction" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcIncompPrep" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="raProcCompleted" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cfProcOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcScreeningHigh" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcScreeningLowRisk" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcIleoscopy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfProcColonoscopy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfColFindNormal" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfColfindHemorrhoids" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfColFindDivert" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfColFindAVM" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="COL" childColumns="id" childConditions="" parentTable="proc_main" parentColumns="id" parentConditions="" />
  <table type="add" name="MedicalHistory">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="uti" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="dialysis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="renalFailure" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="capd" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="uri" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tb" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="sleepApnea" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pneumonia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="orthopnea" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="dyspnea" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="copd" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="asthma" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfMedHistOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfNeophrolithiasis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfBenignHypertrophy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="vrsa" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="mrsa" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="sepsis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hiv" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="sickleCell" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="radHx" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hemophilia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="chemotherapy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="caHem" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="bldDisorder" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="anemia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="nbEndometrialCancerAge" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="cfEndometrialCancer" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="nbOvarianCancerAge" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="cfOvarianCancer" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pregnancy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPortalHTN" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hepOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cirrhosis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDiverticulitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="ulcer" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="ulcColitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="oddi" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="sbo" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="ibs" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="foodImpact" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gastritis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hPylori" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gerd" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="ibd" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="barretts" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="esophagitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="dysphagia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="crohns" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="adenoPolyp" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfHyperlipidemia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="wtChange" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="thyroidAbnl" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="steroid" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="diabetes" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDeepVienThrom" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="defib" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="valvular" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="rheumFever" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pvd" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pacemaker" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="murmur" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="mi" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="htn" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="dysrhythmia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="chf" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="angina" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDementia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="paralysis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="neuromuscular" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="back" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="arthritis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="parasthesia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="seizure" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="syncope" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="MedicalHistory" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="MedHistOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbMedHistOther" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="MedHistOther" childColumns="id" childConditions="" parentTable="MedicalHistory" parentColumns="id" parentConditions="" />
  <table type="add" name="MedHistHemCancer">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbMedHistHemCancer" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="MedHistHemCancer" childColumns="id" childConditions="" parentTable="MedicalHistory" parentColumns="id" parentConditions="" />
  <table type="add" name="SurgicalHistory">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="smBowelTransp" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pancTransp" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="kidneyTransp" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="lungTransplant" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="liverTransp" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="heartTransp" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="lobectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="vagHys" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tubal" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tah" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfSleeveGastrectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRouxenY" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gastrectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gastrectomyPT" key="False">
      <Domain Type="Enumerated">
        <Item>Partial</Item>
        <Item>Total</Item>
      </Domain>
    </column>
    <column name="esophagectomyPT" key="False">
      <Domain Type="Enumerated">
        <Item>Partial</Item>
        <Item>Total</Item>
      </Domain>
    </column>
    <column name="jTube" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gTube" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gastrojejunostomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="billroth2" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="billroth1" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pyloroplasty" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gastroplasty" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="esophagectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="heller" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="raColectomyWith" key="False">
      <Domain Type="Enumerated">
        <Item>ileostomy</Item>
        <Item>ileo-anal pouch</Item>
        <Item>Koch pouch</Item>
      </Domain>
    </column>
    <column name="cfHemorrhoidectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRHemicolectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfLHemicolectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="totColect" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tiResect" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="segColect" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="colostomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="valveReplace" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cabg" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="whipple" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="sphincteroplasty" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pancSurg" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="pancResect" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="liverSurg" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cystRemoval" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cholecystectomy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="bilBypass" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="SurgicalHistory" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="SurgHistOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherSurgHist" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="SurgHistOther" childColumns="id" childConditions="" parentTable="SurgicalHistory" parentColumns="id" parentConditions="" />
  <table type="add" name="VaricesOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbVaricesOther" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="VaricesOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="EvidenceOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbEvidenceOther" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="EvidenceOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="LiverDiseaseEtiologyOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbEtiologyOther" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="LiverDiseaseEtiologyOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="LiverDiseaseAlcohol">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="raDrinkingStatus" key="False">
      <Domain Type="Enumerated">
        <Item>Current drinker</Item>
        <Item>Former drinker</Item>
      </Domain>
    </column>
    <column name="tbAlcoholDetailComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="LiverDiseaseAlcohol" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndOtherSuspectedMal">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbIndOtherSuspectedMal" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="IndOtherSuspectedMal" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsColRecCancer">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cbColCancerPath5" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbColCancerPath4" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbColCancerPath3" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbColCancerPath2" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbColCancerPath1" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbColCancerYear5" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbColCancerYear4" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbColCancerYear3" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbColCancerYear2" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbColCancerYear1" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="raColCancerIsInitial" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cbMScore" key="False">
      <Domain Type="Enumerated">
        <Item>M0:No distant metastasis</Item>
        <Item>M1:Distant metastasis identified</Item>
        <Item>MX:No definite metastasis seen</Item>
      </Domain>
    </column>
    <column name="cbNScore" key="False">
      <Domain Type="Enumerated">
        <Item>N0:No nodes</Item>
        <Item>N1:Regional</Item>
        <Item>N2:Nodes cannot be assessed</Item>
      </Domain>
    </column>
    <column name="cbTScore" key="False">
      <Domain Type="Enumerated">
        <Item>T0:No tumor identified</Item>
        <Item>T1:Lamina propria/submucosa</Item>
        <Item>T2:Muscularis propria</Item>
        <Item>T3:Serosa/adventitia</Item>
        <Item>T4:Surrounding organs</Item>
        <Item>TX:Tumor cannot be assessed</Item>
      </Domain>
    </column>
    <column name="cbCOlCancerIndexLocation" key="False">
      <Domain Type="Enumerated">
        <Item>Rectum</Item>
        <Item>Sigmoid colon</Item>
        <Item>Descending colon</Item>
        <Item>Splenic flexure</Item>
        <Item>Transverse colon</Item>
        <Item>Hepatic flexure</Item>
        <Item>Ascending colon</Item>
        <Item>Terminal ileum</Item>
        <Item>Cecum</Item>
      </Domain>
    </column>
    <column name="cbColCancerPathIndex" key="False">
      <Domain Type="Enumerated">
        <Item>cancer/well-differentiated</Item>
        <Item>cancer/poorly-differentiated</Item>
      </Domain>
    </column>
    <column name="nbColRecCancerIndexYear" key="False">
      <Domain Type="TinyInteger" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsColRecCancer" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsAdPolyps">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cbAdPolypYear5" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypYear4" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypYear3" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypYear2" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypYear1" key="False">
      <Domain Type="Enumerated">
        <Item>2009</Item>
        <Item>2008</Item>
        <Item>2007</Item>
        <Item>2006</Item>
        <Item>2005</Item>
        <Item>2004</Item>
        <Item>2003</Item>
        <Item>2002</Item>
        <Item>2001</Item>
        <Item>2000</Item>
        <Item>1999</Item>
        <Item>1998</Item>
        <Item>1997</Item>
        <Item>1996</Item>
        <Item>1995</Item>
        <Item>1994</Item>
        <Item>1993</Item>
        <Item>1992</Item>
        <Item>1991</Item>
        <Item>1990</Item>
        <Item>1989</Item>
        <Item>1988</Item>
        <Item>1987</Item>
        <Item>1986</Item>
        <Item>1985</Item>
        <Item>1984</Item>
        <Item>1983</Item>
        <Item>1982</Item>
        <Item>1981</Item>
        <Item>1980</Item>
        <Item>1979</Item>
        <Item>1978</Item>
        <Item>1977</Item>
        <Item>unknown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypPath5" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypPath4" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypPath3" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypPath2" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbAdPolypPath1" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="raAdPolypIsInitial" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cbAdPolypLocationIndex" key="False">
      <Domain Type="Enumerated">
        <Item>cecum to splenic flexure</Item>
        <Item>descending colon to rectum</Item>
      </Domain>
    </column>
    <column name="cbAdPolypPathIndex" key="False">
      <Domain Type="Enumerated">
        <Item>cancer</Item>
        <Item>carcinoma in situ</Item>
        <Item>high grade dysplasia</Item>
        <Item>tubulovillous adenoma</Item>
        <Item>tubular adenoma &lt; 1 cm</Item>
        <Item>tubular adenoma &gt;= 1 cm</Item>
        <Item>serrated adenoma</Item>
        <Item>hyperplastic polyp</Item>
        <Item>inflammatory polyp</Item>
        <Item>lymphoid aggregate</Item>
        <Item>normal mucosa</Item>
        <Item>no polyp found</Item>
        <Item>unkown</Item>
      </Domain>
    </column>
    <column name="cbNoAdenomsIndex" key="False">
      <Domain Type="Enumerated">
        <Item>0</Item>
        <Item>1-2</Item>
        <Item>3-4</Item>
        <Item>5-9</Item>
        <Item>&gt;9</Item>
      </Domain>
    </column>
    <column name="nbAdPolypIndexYear" key="False">
      <Domain Type="TinyInteger" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsAdPolyps" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsFamHistPolyps">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbFamHistPolypOther" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="nbFamHistPolypChild" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbFamHistPolypSibling" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbFamHistPolypGrandparent" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbFamHistPolypParent" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="cfFamHistPolypOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistPolypChild" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistPolypSibling" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistPolypGrandparent" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistPolypParent" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsFamHistPolyps" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsFamHistCancer">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="nbFamHistCancerChildAge" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbFamHistCancerSiblingAge" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbFamHistCancerGrandparentAge" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="nbFamHistCancerParentAge" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="tbFamHistCancerOther" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfFamHistCancerChild" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistCancerParent" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistCancerGrandparent" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistCancerSibling" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfFamHistCancerOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsFamHistCancer" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsAbnormalXray">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfComputedTomography" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfXFindWallThickening" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfXFindSusPathology" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfXFindStricture" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfXFindPolyp" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfBariumEnema" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfXFindMass" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfCTMR" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsAbnormalXray" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsOtherBloodLoss">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherGILoss" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsOtherBloodLoss" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsHematochezia">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="raHematocheziaType" key="False">
      <Domain Type="Enumerated">
        <Item>Outlet (defined as bright red blood with normal stools)</Item>
        <Item>Suspected colonic (blood mixed with stool)</Item>
        <Item>Frank hemorrhage (blood / clots with or without stool)</Item>
      </Domain>
    </column>
    <column name="raHematocheziaFreq" key="False">
      <Domain Type="Enumerated">
        <Item>&lt;1/week</Item>
        <Item>1-3x/week</Item>
        <Item>&gt;4-6x/week</Item>
        <Item>daily</Item>
      </Domain>
    </column>
    <column name="nbHematocheziaDuration" key="False">
      <Domain Type="TinyInteger" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsHematochezia" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsFOBT">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="raFOBT" key="False">
      <Domain Type="Enumerated">
        <Item>Digital rectal exam</Item>
        <Item>Home screening</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="IndicationsFOBT" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsAnemia">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfIronDeficiency" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tbAnemiaOtherType" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfAnemiaOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPernAnemia" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsAnemia" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsOtherIntervention">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherTherInterventions" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsOtherIntervention" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsStent">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfStentPlacement" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tbStentComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfStentRemoval" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStentReplacement" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsStent" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsSxOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherSx" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsSxOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsDiarrhea">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="raDiarrheaDetails" key="False">
      <Domain Type="Enumerated">
        <Item>acute</Item>
        <Item>chronic (&gt;= 3 months)</Item>
      </Domain>
    </column>
    <column name="cfFreqStools" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tbDiarrheaComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="nbNoDuringSleep" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="cfIncontinence" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfLiquidStools" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="nbNoPer24" key="False">
      <Domain Type="TinyInteger" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsDiarrhea" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsConstipation">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="nbNoOfStools" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="tbConstipationComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfSmallCalStools" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfInfreqStools" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDiffEvac" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsConstipation" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="IndicationsOtherDiagnosis">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherDx" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="IndicationsOtherDiagnosis" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="PreprocSedMedOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherSedMed" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="PreprocSedMedOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="dgvSedationMeds">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Medication" key="False">
      <Domain Type="String" />
    </column>
    <column name="Dose" key="False">
      <Domain Type="String" />
    </column>
    <column name="Route" key="False">
      <Domain Type="String" />
    </column>
  </table>
  <fk type="add" childTable="dgvSedationMeds" childColumns="fk" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="PreProcAntibiotics">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherIndAnti" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="gCheckFlag1" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPancPseudocyst" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfCongenitalMalform" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfMitralValve" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfSynthGraft" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfHistOfEndocarditis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfIndAntiOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfCirrhosis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfObBileDuct" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfHypertrophicCard" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRheumValvDysfunction" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfSystemicShunt" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfAntiProstValve" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfOtherAntibiotic" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="PreProcAntibiotics" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="dgvAntibiotics">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Medication" key="False">
      <Domain Type="String" />
    </column>
    <column name="Dose" key="False">
      <Domain Type="String" />
    </column>
    <column name="Route" key="False">
      <Domain Type="String" />
    </column>
  </table>
  <fk type="add" childTable="dgvAntibiotics" childColumns="fk" childConditions="" parentTable="PreProcAntibiotics" parentColumns="id" parentConditions="" />
  <table type="add" name="PreprocAntibioticsOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherAntiMed" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="PreprocAntibioticsOther" childColumns="id" childConditions="" parentTable="PreProcAntibiotics" parentColumns="id" parentConditions="" />
  <table type="add" name="PreProcMonitoringOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbMonitoringOther" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="PreProcMonitoringOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="PreProcSuppOxygen">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="nbOxygenFlow" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="tbOxygenComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbDeliveryMethod" key="False">
      <Domain Type="Enumerated">
        <Item>Blow by</Item>
        <Item>Face mask</Item>
        <Item>Nasal prongs</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="PreProcSuppOxygen" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="gridPersonel">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="c1" key="False">
      <Domain Type="String" />
    </column>
    <column name="c2" key="False">
      <Domain Type="String" />
    </column>
    <column name="c3" key="False">
      <Domain Type="String" />
    </column>
    <column name="proc_grid_uid" key="False">
      <Domain Type="String" />
    </column>
    <column name="procedure_uid" key="False">
      <Domain Type="String" />
    </column>
    <column name="proc_grid_row_uid" key="False">
      <Domain Type="String" />
    </column>
    <column name="grid_id" key="False">
      <Domain Type="String" />
    </column>
    <column name="addid" key="False">
      <Domain Type="String" />
    </column>
    <column name="diff" key="False">
      <Domain Type="String" />
    </column>
  </table>
  <fk type="add" childTable="gridPersonel" childColumns="fk" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="dgvProcInstruments">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Instrument" key="False">
      <Domain Type="String" />
    </column>
    <column name="gDataGridViewColumn8" key="False">
      <Domain Type="String" />
    </column>
  </table>
  <fk type="add" childTable="dgvProcInstruments" childColumns="fk" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="ProcIncompOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherProcIncomplete" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="ProcIncompOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="ProcOther">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherProcPerformed" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="ProcOther" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="ProcIleoscopy">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfStomaStentPlacement" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStomaAblation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStomaRemoveSnare" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStomaRemoveBicap" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStomaControlBleeding" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRemoveForeign" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStomaBiopsy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="ProcIleoscopy" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="ProcColonoscopy">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfBalloonDilation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStentPlacement" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfAblation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRemovalSnare" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRemovalBicap" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDirectedInjections" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfControlBleeding" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfBiopsy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfRemovOfForBody" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="ProcColonoscopy" childColumns="id" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="proc_find">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="caption" key="False">
      <Domain Type="Enumerated">
        <Item>Diverticulosis</Item>
        <Item>Polyp</Item>
        <Item>Ulcer</Item>
      </Domain>
    </column>
    <column name="points" key="False">
      <Domain Type="String" />
    </column>
    <column name="x" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="y" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="txtLeft" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="txtTop" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="kind" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="regions" key="False">
      <Domain Type="Integer" />
    </column>
    <column name="diff" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="procType" key="False">
      <Domain Type="String" Width="5" />
    </column>
  </table>
  <fk type="add" childTable="proc_find" childColumns="fk" childConditions="" parentTable="COL" parentColumns="id" parentConditions="" />
  <table type="add" name="Diverticulosis">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cbTest" key="False">
      <Domain Type="Enumerated">
        <Item>a</Item>
        <Item>b</Item>
        <Item>c</Item>
      </Domain>
    </column>
    <column name="nonHem" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="hem" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="bleedRate" key="False">
      <Domain Type="Enumerated">
        <Item>Oozing</Item>
        <Item>Spurting</Item>
        <Item>Inactive</Item>
        <Item>Uncertain</Item>
      </Domain>
    </column>
    <column name="cbEndLoc" key="False">
      <Domain Type="Enumerated">
        <Item>Anastamosis site</Item>
        <Item>Anus</Item>
        <Item>Rectum</Item>
        <Item>Sigmoid colon</Item>
        <Item>Descending colon</Item>
        <Item>Splenic flexure</Item>
        <Item>Transverse colon</Item>
        <Item>Hepatic flexure</Item>
        <Item>Ascending colon</Item>
        <Item>Cecum</Item>
        <Item>Terminal ileum</Item>
        <Item>Ileum</Item>
      </Domain>
    </column>
    <column name="cbStartLoc" key="False">
      <Domain Type="Enumerated">
        <Item>Anastamosis site</Item>
        <Item>Anus</Item>
        <Item>Rectum</Item>
        <Item>Sigmoid colon</Item>
        <Item>Descending colon</Item>
        <Item>Splenic flexure</Item>
        <Item>Transverse colon</Item>
        <Item>Hepatic flexure</Item>
        <Item>Ascending colon</Item>
        <Item>Cecum</Item>
        <Item>Terminal ileum</Item>
        <Item>Ileum</Item>
      </Domain>
    </column>
    <column name="diverticulitis" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="comments" key="False">
      <Domain Type="String" Width="512" />
    </column>
    <column name="imageTaken" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbDivertDx" key="False">
      <Domain Type="Enumerated">
        <Item>Diverticulitis of colon</Item>
        <Item>Diverticulitis of colon  with bleeding</Item>
        <Item>Diverticulitis of ileum</Item>
        <Item>Diverticulitis of ileum with bleeding</Item>
        <Item>Diverticulosis of colon</Item>
        <Item>Diverticulosis of colon  with bleeding</Item>
        <Item>Diverticulosis of ileum</Item>
        <Item>Diverticulosis of ileum with bleeding</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="Diverticulosis" childColumns="id" childConditions="" parentTable="proc_find" parentColumns="id" parentConditions="" />
  <table type="add" name="Polyp">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbPolypComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfPolypImagesTaken" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPolypTattoo" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="raPolypTissRetrieved" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="cbPolypRemoved" key="False">
      <Domain Type="Enumerated">
        <Item>totally removed</Item>
        <Item>partially removed</Item>
        <Item>removed piecemeal</Item>
        <Item>not removed</Item>
      </Domain>
    </column>
    <column name="cfPolypSnareWSaline" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbPolypSnareWCautery" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPolypSnaerWOCautery" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPolypBiopWCautery" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPolypBiopWOCautery" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPolypTherNonHemo" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfPolypHemostatic" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="raPolypType" key="False">
      <Domain Type="Enumerated">
        <Item>pedunculated</Item>
        <Item>sessile</Item>
        <Item>flat with depressed area</Item>
        <Item>flat without depressed area</Item>
      </Domain>
    </column>
    <column name="cbPolypDx" key="False">
      <Domain Type="Enumerated">
        <Item>Polyp, colon</Item>
        <Item>Polyp, anus</Item>
        <Item>Polyp, rectum</Item>
      </Domain>
    </column>
    <column name="nbPolypSize" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="cfPolypDiminutive" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbPolypLocation" key="False">
      <Domain Type="Enumerated">
        <Item>Rectum</Item>
        <Item>Sigmoid colon</Item>
        <Item>Descending colon</Item>
        <Item>Splenic flexure</Item>
        <Item>Transverse colon</Item>
        <Item>Hepatic flexure</Item>
        <Item>Ascending colon</Item>
        <Item>Terminal ileum</Item>
        <Item>Cecum</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="Polyp" childColumns="id" childConditions="" parentTable="proc_find" parentColumns="id" parentConditions="" />
  <table type="add" name="TherapyNonHemostatic">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfTherNonHemAPC" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemStent" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemLaser" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemInjection" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemHeaterProbe" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemEMR" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemDilation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemClip" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherNonHemBanding" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="TherapyNonHemostatic" childColumns="id" childConditions="" parentTable="Polyp" parentColumns="id" parentConditions="" />
  <table type="add" name="APCNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbAPCNonHemWatts" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbAPCNonHemLitres" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbNonHemAPCOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbNonHemAPCComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="APCNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="OtherNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbOtheRNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbOtherNonHemDescription" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="OtherNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="StentNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbStentNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbStentNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="cfStentNonHemContrast" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStentNonHemFluoro" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStentNonHemdistalClips" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfStentNonHemProximalClips" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbStentNonHemGuidewire" key="False">
      <Domain Type="Enumerated">
        <Item>Jag</Item>
        <Item>Savary</Item>
      </Domain>
    </column>
    <column name="tbStentNonHemFlange" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbStentNonHemDiameter" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbStentNonHemCovered" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbStentNonHemLength" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbStentNonHemType" key="False">
      <Domain Type="Enumerated">
        <Item>Barbed Amsterdam</Item>
        <Item>Biliary</Item>
        <Item>Diamond</Item>
        <Item>Instent</Item>
        <Item>Staight with Introducer</Item>
        <Item>Wallston</Item>
        <Item>Mocrovasive Ultraflex</Item>
        <Item>Microvasive Wallstent</Item>
        <Item>Microvasive</Item>
        <Item>Schneider WallNH_Stent</Item>
        <Item>Microvasive Nitinol</Item>
        <Item>Microvasive Esophageal Stent</Item>
        <Item>Wilson Cook Z Stent</Item>
        <Item>Other, see comments</Item>
      </Domain>
    </column>
    <column name="tbStentNonHemNumber" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="StentNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="LaserNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbLaserNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbLaserNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbLaserNonHemSeconds" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbLaserNonHemJoules" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbLaserNonHemWatts" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="j" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="LaserNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="InjectionNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbInjectionNonHemVolume" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbInjectionNonHemNumber" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbInjectionNonHemCombined" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbInjectionnonHemInjectant" key="False">
      <Domain Type="Enumerated">
        <Item>Botox</Item>
        <Item>Epinephrine</Item>
        <Item>Epinephrine 1:10000</Item>
        <Item>Ethanolamine</Item>
        <Item>Na Morrhuate</Item>
        <Item>Na tetradecyl</Item>
        <Item>Saline</Item>
        <Item>Spot</Item>
        <Item>Triamcinolone</Item>
        <Item>Other, see comments</Item>
      </Domain>
    </column>
    <column name="gComboBox1" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbInjectionNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="InjectionNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="HeaterProbeNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbHeaterProbeNonHemWatts" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbHeaterProbeNonHemInstrument" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbHeaterProbeNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbHeaterProbeNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="HeaterProbeNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="EMRNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbEMRNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfEMRNonHemSample" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfEMRNonHemCompleteResection" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tbEMRNonHemInstrument" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbEMRNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="EMRNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="DilationNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbDilationNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbDilationNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="cbDilationNonHemTolerance" key="False">
      <Domain Type="Enumerated">
        <Item>Excellent</Item>
        <Item>Good</Item>
        <Item>Fair</Item>
        <Item>Poor</Item>
      </Domain>
    </column>
    <column name="cbDilationNonHemHeme" key="False">
      <Domain Type="Enumerated">
        <Item>Minimal</Item>
        <Item>moderate</Item>
        <Item>None</Item>
        <Item>Significant</Item>
      </Domain>
    </column>
    <column name="cbDilationNonHemResistance" key="False">
      <Domain Type="Enumerated">
        <Item>Minimal</Item>
        <Item>Moderate</Item>
        <Item>None</Item>
        <Item>Significant</Item>
      </Domain>
    </column>
    <column name="tbDilationNonHemPressure" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbDilationNonHemTime" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbDilationNonHemSize4" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbDilationNonHemSize3" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbDilationNonHemSize2" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbDilationNonHemSize1" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cfDilationNonHemWire" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfDilationNonHemFluoroscopy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cbDilationNonHemType" key="False">
      <Domain Type="Enumerated">
        <Item>Balloon</Item>
        <Item>Wire-guided bougie (Savary type)</Item>
        <Item>Rubber bougie (Hurst/ Maloney type)</Item>
        <Item>Other, see comments</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="DilationNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="ClipNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbClipNonHemPlaced" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbClipNonHemFired" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbClipNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbClipNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="ClipNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="BandingNonHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbBandingNonHemPlaced" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbBandingNonHemTotal" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbBandingNonHemDevice" key="False">
      <Domain Type="Enumerated">
        <Item>Two shooter</Item>
        <Item>Six shooter</Item>
        <Item>Ten shooter</Item>
        <Item>Other, see comments</Item>
      </Domain>
    </column>
    <column name="cbBandingNonHemOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbBandingNonHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="BandingNonHem" childColumns="id" childConditions="" parentTable="TherapyNonHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="TherapyHemostatic">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="cfTherHemAPC" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherHemOther" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherHemLaser" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherHemInjection" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherHemHeaterProbe" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherHemClip" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherHemBipol" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="cfTherHemBanding" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="TherapyHemostatic" childColumns="id" childConditions="" parentTable="Polyp" parentColumns="id" parentConditions="" />
  <table type="add" name="APCHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="gTextBox1" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbAPCHemProcedureOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbAPCHemLitres" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbAPCHemWatts" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbAPCHemBleedingOutcom" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="APCHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="OtherHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbOtherHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbOtherHemProcedureOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="cbOtherHemBleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
    <column name="tbOtherHemDescription" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="OtherHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="LaserHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbLaserHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbLaserProcedureOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbLaserHemSeconds" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbLaserHemJoules" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbLaserHemWatts" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbLaserHemType" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbLaserHemBleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="LaserHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="InjectionHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbInjectionHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbInjectionProcedureOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="cbInjectionHemBleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
    <column name="tbInjectionHemVolume" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbInjectionHemNumber" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbInjectionHemCombined" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbInjectionHemInjectant" key="False">
      <Domain Type="Enumerated">
        <Item>Botox</Item>
        <Item>Epinephrine</Item>
        <Item>Epinephrine 1:10000</Item>
        <Item>Ethanolamine</Item>
        <Item>Na Morrhuate</Item>
        <Item>Na Tetradecyl</Item>
        <Item>Saline</Item>
        <Item>Other, see comments</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="InjectionHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="HeaterProbeHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="gTextBox1" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbHeaterProbeProcedureOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="cbHeaterProbeBleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
    <column name="tbHeaterProbeHemWatts" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbHeaterProbeInstrument" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="HeaterProbeHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="ClipHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbClipHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="gComboBox1" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="cbClipHemBleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
    <column name="tbClipHemPlaced" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbClipHemFired" key="False">
      <Domain Type="String" Width="32767" />
    </column>
  </table>
  <fk type="add" childTable="ClipHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="BipolarHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbBiCapHemcomments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbBiCapHemProcedureOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="cbBiCapHemBleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostatis achieved</Item>
      </Domain>
    </column>
    <column name="cfBiCapHemIrrigation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="tbBiCapHemWatts" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbBiCapHemTotalseconds" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="gComboBox1" key="False">
      <Domain Type="Enumerated">
        <Item>Bipolar Probe</Item>
        <Item>Bipolar Probe &amp; injector (gold Probe)</Item>
        <Item>Other probe, see comments</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="BipolarHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="BandingHem">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="tbBandingHemComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbBandingHemProcedureOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="tbBandingHemPlaced" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="tbBandingHemTotalFired" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="cbBandingHemDevice" key="False">
      <Domain Type="Enumerated">
        <Item>Two Shooter</Item>
        <Item>Six Shooter</Item>
        <Item>Ten Shooter</Item>
        <Item>Other, see comments</Item>
      </Domain>
    </column>
    <column name="cbBandingHemBleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="BandingHem" childColumns="id" childConditions="" parentTable="TherapyHemostatic" parentColumns="id" parentConditions="" />
  <table type="add" name="Ulcer">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="gTextBox2" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="NonHemostatic" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="gTextBox1" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="Hemostatic" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="RateOfBleed" key="False">
      <Domain Type="Enumerated">
        <Item>Oozing</Item>
        <Item>Spurting</Item>
        <Item>Inactive</Item>
        <Item>Uncertain</Item>
      </Domain>
    </column>
    <column name="HealedScarred" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="NonBleedingClean" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="DarkSpot" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="AdherentClot" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="VisibleVessel" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="ActiveRecentBleed" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="Ulcer" childColumns="id" childConditions="" parentTable="proc_find" parentColumns="id" parentConditions="" />
  <table type="add" name="HemostaticTherapeuticProcedures">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Injection" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="HeaterProbe" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="Laser" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="BipolarCoagulation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="Clip" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="Banding" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="OtherTherapy" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="APC" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="HemostaticTherapeuticProcedures" childColumns="id" childConditions="" parentTable="Ulcer" parentColumns="id" parentConditions="" />
  <table type="add" name="HemostaticInjection">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Injectant" key="False">
      <Domain Type="Enumerated">
        <Item>Botox</Item>
        <Item>Epinephrine</Item>
        <Item>Epinephrine 1:10000</Item>
        <Item>Ethanolamine</Item>
        <Item>Na Morrhuate</Item>
        <Item>Na tetradecyl</Item>
        <Item>Saline</Item>
        <Item>Other, see comments</Item>
      </Domain>
    </column>
    <column name="CombinedWith" key="False">
      <Domain Type="String" Width="100" />
    </column>
    <column name="Comments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="ProceduralOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Technically successful</Item>
        <Item>Technically unsuccessful</Item>
      </Domain>
    </column>
    <column name="NumberOfInjections" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="BleedingOutcome" key="False">
      <Domain Type="Enumerated">
        <Item>Bleeding continues</Item>
        <Item>Bleeding precipitated</Item>
        <Item>Hemostasis achieved</Item>
      </Domain>
    </column>
    <column name="TotalVolumeInjected" key="False">
      <Domain Type="TinyInteger" />
    </column>
  </table>
  <fk type="add" childTable="HemostaticInjection" childColumns="id" childConditions="" parentTable="HemostaticTherapeuticProcedures" parentColumns="id" parentConditions="" />
  <table type="add" name="EGD">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="ProcedureDate" key="False">
      <Domain Type="DateTime" />
    </column>
    <column name="Test" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="SurgicalHistory" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="EntireExamWNL" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="Systolic" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="Pulse" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="Diastolic" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="Weight" key="False">
      <Domain Type="SmallInteger" MaxValue="2000" />
    </column>
    <column name="Height" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="PEComments" key="False">
      <Domain Type="String" Width="32767" />
    </column>
    <column name="PhysicalExamPerformed" key="False">
      <Domain Type="DateTime" />
    </column>
    <column name="OtherSymptoms" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="WeightLoss" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="GISxInImmuneCompromisedHost" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="Diarrhea" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="Constipation" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="ChangeInBowelHabits" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
    <column name="AbdominalPainBloating" key="False">
      <Domain Type="TinyInteger" MaxValue="2" MinValue="0" />
    </column>
  </table>
  <fk type="add" childTable="EGD" childColumns="id" childConditions="" parentTable="proc_main" parentColumns="id" parentConditions="" />
  <fk type="add" childTable="SurgicalHistory" childColumns="id" childConditions="" parentTable="EGD" parentColumns="id" parentConditions="" />
  <fk type="add" childTable="SurgHistOther" childColumns="id" childConditions="" parentTable="SurgicalHistory" parentColumns="id" parentConditions="" />
  <table type="add" name="DrawFindings">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="caption" key="False">
      <Domain Type="Enumerated">
        <Item>Ulcer</Item>
      </Domain>
    </column>
    <column name="points" key="False">
      <Domain Type="String" />
    </column>
    <column name="x" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="y" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="txtLeft" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="txtTop" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="kind" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="regions" key="False">
      <Domain Type="Integer" />
    </column>
    <column name="diff" key="False">
      <Domain Type="TinyInteger" />
    </column>
    <column name="procType" key="False">
      <Domain Type="String" Width="5" />
    </column>
  </table>
  <fk type="add" childTable="DrawFindings" childColumns="fk" childConditions="" parentTable="EGD" parentColumns="id" parentConditions="" />
  <fk type="add" childTable="Ulcer" childColumns="id" childConditions="" parentTable="DrawFindings" parentColumns="id" parentConditions="" />
  <fk type="add" childTable="HemostaticTherapeuticProcedures" childColumns="id" childConditions="" parentTable="Ulcer" parentColumns="id" parentConditions="" />
  <fk type="add" childTable="HemostaticInjection" childColumns="id" childConditions="" parentTable="HemostaticTherapeuticProcedures" parentColumns="id" parentConditions="" />
  <table type="add" name="Staff">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="fk" key="False">
      <Domain Type="UniqueIdentifier" />
    </column>
    <column name="Country" key="False">
      <Domain Type="Enumerated">
        <Item>USA</Item>
        <Item>Canada</Item>
        <Item>Somewhere Else</Item>
      </Domain>
    </column>
    <column name="Gender" key="False">
      <Domain Type="Enumerated">
        <Item>Unknown</Item>
        <Item>Male</Item>
        <Item>Female</Item>
      </Domain>
    </column>
    <column name="State" key="False">
      <Domain Type="Enumerated">
        <Item>AK</Item>
        <Item>AL</Item>
        <Item>AR</Item>
        <Item>AZ</Item>
        <Item>CA</Item>
        <Item>CO</Item>
        <Item>CT</Item>
        <Item>DC</Item>
        <Item>DE</Item>
        <Item>FL</Item>
        <Item>GA</Item>
        <Item>HI</Item>
        <Item>IA</Item>
        <Item>ID</Item>
        <Item>IL</Item>
        <Item>IN</Item>
        <Item>KY</Item>
        <Item>LO</Item>
        <Item>MA</Item>
        <Item>MD</Item>
        <Item>ME</Item>
        <Item>MI</Item>
        <Item>MN</Item>
        <Item>MO</Item>
        <Item>NC</Item>
        <Item>ND</Item>
        <Item>NE</Item>
        <Item>NJ</Item>
        <Item>NH</Item>
        <Item>NM</Item>
        <Item>NY</Item>
        <Item>OH</Item>
        <Item>OK</Item>
        <Item>OR</Item>
        <Item>PA</Item>
        <Item>RI</Item>
        <Item>SC</Item>
        <Item>SD</Item>
        <Item>TN</Item>
        <Item>TX</Item>
        <Item>UT</Item>
        <Item>VI</Item>
        <Item>VT</Item>
        <Item>WA</Item>
        <Item>WI</Item>
        <Item>WV</Item>
        <Item>WY</Item>
      </Domain>
    </column>
    <column name="Fax" key="False">
      <Domain Type="String" Width="12" />
    </column>
    <column name="Pager" key="False">
      <Domain Type="String" Width="12" />
    </column>
    <column name="Phone2" key="False">
      <Domain Type="String" Width="12" />
    </column>
    <column name="Email" key="False">
      <Domain Type="String" Width="30" />
    </column>
    <column name="Address2" key="False">
      <Domain Type="String" Width="50" />
    </column>
    <column name="ZipCode" key="False">
      <Domain Type="String" Width="10" />
    </column>
    <column name="Phone1" key="False">
      <Domain Type="String" Width="12" />
    </column>
    <column name="Address1" key="False">
      <Domain Type="String" Width="50" />
    </column>
    <column name="City" key="False">
      <Domain Type="String" Width="30" />
    </column>
    <column name="MiddleName" key="False">
      <Domain Type="String" Width="20" />
    </column>
    <column name="LastName" key="False">
      <Domain Type="String" Width="30" />
    </column>
    <column name="FirstName" key="False">
      <Domain Type="String" Width="30" />
    </column>
    <column name="GRadioArray" key="False">
      <Domain Type="Enumerated">
        <Item>Yes</Item>
        <Item>No</Item>
      </Domain>
    </column>
    <column name="Other" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="HawaiianPacificIslander" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="Asian" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="AmericanIndian" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="Black" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="White" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="PulmonaryMedicine" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="FamilyMedicine" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="Gastroenterology" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="GIPediatrics" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="InternalMedicine" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="Surgery" key="False">
      <Domain Type="Boolean" />
    </column>
    <column name="DegreeYear" key="False">
      <Domain Type="SmallInteger" />
    </column>
    <column name="PrimarySpecialty" key="False">
      <Domain Type="Enumerated">
        <Item>Surgery</Item>
        <Item>Internal Medicine</Item>
        <Item>GI Pediatrics</Item>
        <Item>Gastroenterology</Item>
        <Item>Family Medicine</Item>
        <Item>Pulmonary Medicine</Item>
      </Domain>
    </column>
    <column name="Degree" key="False">
      <Domain Type="Enumerated">
        <Item>MD</Item>
        <Item>ND</Item>
        <Item>MPH</Item>
      </Domain>
    </column>
  </table>
  <fk type="add" childTable="Staff" childColumns="fk" childConditions="" parentTable="Lobby" parentColumns="id" parentConditions="" />
  <table type="add" name="Medications">
    <column name="id" key="True">
      <Domain Type="UniqueIdentifier" />
    </column>
  </table>
  <fk type="add" childTable="Medications" childColumns="id" childConditions="" parentTable="Lobby" parentColumns="id" parentConditions="" />
</DDLs>